<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  

  
  <title>一起学Excel</title>
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  <meta property="og:type" content="website">
<meta property="og:title" content="一起学Excel">
<meta property="og:url" content="https://lecoder.gitee.io/study-excel/page/52/index.html">
<meta property="og:site_name" content="一起学Excel">
<meta property="og:locale" content="zh_CN">
<meta property="article:author" content="lijile">
<meta name="twitter:card" content="summary">
  
  
    <link rel="icon" href="/favicon.png">
  
  
    <link href="//fonts.googleapis.com/css?family=Source+Code+Pro" rel="stylesheet" type="text/css">
  
  
<link rel="stylesheet" href="/study-excel/css/style.css">

<meta name="generator" content="Hexo 6.3.0"></head>

<body>
  <div id="container">
    <div id="wrap">
      <header id="header">
  <div id="banner"></div>
  <div id="header-outer" class="outer">
    <div id="header-title" class="inner">
      <h1 id="logo-wrap">
        <a href="/study-excel/" id="logo">一起学Excel</a>
      </h1>
      
    </div>
    <div id="header-inner" class="inner">
      <nav id="main-nav">
        <a id="main-nav-toggle" class="nav-icon"></a>
        
          <a class="main-nav-link" href="/study-excel/">Home</a>
        
          <a class="main-nav-link" href="/study-excel/archives">Archives</a>
        
      </nav>
      <nav id="sub-nav">
        
        <a id="nav-search-btn" class="nav-icon" title="搜索"></a>
      </nav>
      <div id="search-form-wrap">
        <form action="//google.com/search" method="get" accept-charset="UTF-8" class="search-form"><input type="search" name="q" class="search-form-input" placeholder="Search"><button type="submit" class="search-form-submit">&#xF002;</button><input type="hidden" name="sitesearch" value="https://lecoder.gitee.io/study-excel"></form>
      </div>
    </div>
  </div>
</header>
      <div class="outer">
        <section id="main">
  
    <article id="post-excel-clipboard-basic-usage" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-clipboard-basic-usage/" class="article-date">
  <time datetime="2022-11-23T08:00:49.368Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/">复制与粘贴</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/%E5%9F%BA%E7%A1%80/">基础</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-clipboard-basic-usage/">Excel 中剪贴板的基本用法</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>在使用 Excel 的过程中，我们一般只会复制与粘贴最后一次复制内容。其实使用 Excel 的剪贴板功能可以获取最多 24 项之前复制的内容。</p>
<h2 id="打开-Excel-剪贴板"><a href="#打开-Excel-剪贴板" class="headerlink" title="打开 Excel 剪贴板"></a>打开 Excel 剪贴板</h2><p>转到功能区→开始选项卡→剪贴板命令组，点击右下角斜箭头即可打开剪贴板。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_6050f0eb03284002c7fa69afa5c8292d.png"></p>
<h2 id="从剪贴板粘贴内容"><a href="#从剪贴板粘贴内容" class="headerlink" title="从剪贴板粘贴内容"></a>从剪贴板粘贴内容</h2><p>方法一：选中要粘贴的目标单元格，再点击剪贴板粘贴的内容。</p>
<p>方法二：选中要粘贴的目标单元格，将鼠标移动到剪贴板上的内容，点击右边出现的下拉菜单箭头，选择“粘贴”选项进行粘贴。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_20248ad511fea285cbd9c28be8259965.png"></p>
<h2 id="剪贴板选项"><a href="#剪贴板选项" class="headerlink" title="剪贴板选项"></a>剪贴板选项</h2><ul>
<li>全部粘贴：按复制从前到后的顺序在目标区域粘贴剪贴板上的所有内容。</li>
<li>全部清空：清空剪贴板上所有内容。</li>
<li>其他显示选项。</li>
</ul>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_00a420a7350ae080d4e395349e499770.png"></p>
<h2 id="多个单元格内容合并粘贴到一个单元格"><a href="#多个单元格内容合并粘贴到一个单元格" class="headerlink" title="多个单元格内容合并粘贴到一个单元格"></a>多个单元格内容合并粘贴到一个单元格</h2><p>利用剪贴板全部粘贴选项，可以将单元格区域内容合并粘贴一个单元格，具体步骤如下：</p>
<p>1.选中要复制的单元格区域并复制。</p>
<p>2.从功能区打开剪贴板。</p>
<p>3.选中目标单元格，双击进入编辑状态。</p>
<p>4.点击剪贴板“全部粘贴”命令，完成粘贴。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_bd93306e58b85bafa8598f960c9f91e7.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-clipboard-basic-usage/" data-id="clatcwg2f00o4xcq6884u3kk5" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-protect-workbook" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-protect-workbook/" class="article-date">
  <time datetime="2022-11-23T08:00:49.368Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E4%BF%9D%E6%8A%A4/">保护</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-protect-workbook/">Excel 保护工作簿</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <h2 id="保护工作簿结构"><a href="#保护工作簿结构" class="headerlink" title="保护工作簿结构"></a>保护工作簿结构</h2><p>如果保护了工作簿结构，用户将无法插入、删除、重命名、移动、复制、隐藏或取消隐藏工作表。设置保护工作簿步骤如下：</p>
<p>1.转到功能区→审阅选项卡→更改命令组，点击“保护工作簿”命令按钮。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_3a02d87b24b067aa674ed944eb3e62ea.png"></p>
<p>2.在弹出的保护结构与窗口菜单中，结构选项前打勾，点击确定。如取消保护操作需要密码才能进行，则在密码框输入取消保护的密码。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_509867bb17c168d8f151cb3c57bdd680.png"></p>
<p>3.完成保护工作簿结构操作。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_d09b899df02530555eb568047740cef5.png"></p>
<h2 id="取消保护"><a href="#取消保护" class="headerlink" title="取消保护"></a>取消保护</h2><p>转到功能区→审阅选项卡→更改命令组，点击保护工作簿命令按钮，即可取消保护工作簿。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-protect-workbook/" data-id="clatcwg3m00p2xcq612c7bhwz" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-set-file-password" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-set-file-password/" class="article-date">
  <time datetime="2022-11-23T08:00:49.368Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E4%BF%9D%E6%8A%A4/">保护</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-set-file-password/">Excel 文件设置打开密码</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>给 Excel 文件设置打开密码后，只有正确输入密码才能打开工作簿进行进一步编辑。设置打开密码步骤如下：</p>
<h2 id="设置打开密码"><a href="#设置打开密码" class="headerlink" title="设置打开密码"></a>设置打开密码</h2><p>1.点击功能区“文件”命令按钮，进入后台视图。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_709a187b9e93b383f346fad2100200dc.gif"></p>
<p>2.在后台视图信息选项页面，点击保护工作簿，在弹出的快捷菜单中选择“用密码进行加密”选项。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_54ccdc7f9e40742ac2f00973009b3919.png"></p>
<p>3.在弹出的“加密文档”菜单中，两次输入设置的密码，完成密码的设置。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_c13faba2bbad73fdc6ee8bd554dbbc9d.png"></p>
<h2 id="取消打开密码"><a href="#取消打开密码" class="headerlink" title="取消打开密码"></a>取消打开密码</h2><p>与设置打开密码步骤一致，在最后一步“加密文档”菜单中，将密码框留空点击确定，即可取消当前打开密码。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_88c6d108d104d59091d9dc02ed069b2c.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-set-file-password/" data-id="clatcwg3p00p4xcq6fx1d9tck" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-set-file-read-only" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-set-file-read-only/" class="article-date">
  <time datetime="2022-11-23T08:00:49.368Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E4%BF%9D%E6%8A%A4/">保护</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-set-file-read-only/">Excel 文件设置只读模式</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <h2 id="设置只读模式"><a href="#设置只读模式" class="headerlink" title="设置只读模式"></a>设置只读模式</h2><p>Excel 文件设置成只读模式后，工作簿只能被查看，不能被编辑。设置只读模式具体步骤如下：</p>
<p>1.点击功能区“文件”命按钮，进入后台视图。</p>
<p>2.在后台视图菜单中，点击另存为，调出另存为菜单。</p>
<p>3.在另存为菜单，点击工具命令中“常规选项”选项，调出常规选项菜单。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_1093a4a184e8f460dd50a3439c9c17e4.png"></p>
<p>4.在常规选项菜单中，使用下列方法设置只读模式：</p>
<p>方法一：设置修改权限密码，只有输入密码才能编辑，否则只读模式查看。具体方法是，在修改密码权限框，输入密码点击确定完成。</p>
<p>方法二：在建议只读选项前打勾，这时候只能查看，无法编辑。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_7701a57f1933d9dd5b8552e165ede86c.png"></p>
<p>5.常规选项设置完毕，点击保存命令，保存工作簿。</p>
<h2 id="取消只读模式"><a href="#取消只读模式" class="headerlink" title="取消只读模式"></a>取消只读模式</h2><p>使用相同的方法到常规选项菜单，删除修改权限密码或者建议只读选项去掉勾，后保存工作簿，即可取消只读模式。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-set-file-read-only/" data-id="clatcwg3w00paxcq6di1t77cl" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-use-conditional-paste-math" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/use-conditional-paste-math/" class="article-date">
  <time datetime="2022-11-23T08:00:49.368Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/">复制与粘贴</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/%E5%9F%BA%E7%A1%80/">基础</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/use-conditional-paste-math/">使用选择性粘贴进行算术运算</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>Excel 的选择性粘贴功能还可用于对粘贴区域的数据进行简单的算术运算，包括加减乘除运算。具体步骤如下：</p>
<h2 id="目标"><a href="#目标" class="headerlink" title="目标"></a>目标</h2><p>对目标区域的数字同时除以1000。</p>
<h2 id="操作步骤"><a href="#操作步骤" class="headerlink" title="操作步骤"></a>操作步骤</h2><p>1.在任意单元格输入数字 10000。</p>
<p>2.复制 10000 所在单元格。</p>
<p>3.选中目标单元格区域。</p>
<p>4.调出选择性粘贴菜单，其中运算选项中选择 “除” ，点击确定完成任务。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_167a15adb5c667a7db497e4bde4349f1.gif"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/use-conditional-paste-math/" data-id="clatcwg6d00rcxcq609qxcbna" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-use-hot-key-copy" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/use-hot-key-copy/" class="article-date">
  <time datetime="2022-11-23T08:00:49.368Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/">复制与粘贴</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/%E5%9F%BA%E7%A1%80/">基础</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/use-hot-key-copy/">使用快捷键快速复制</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>使用快捷键进行复制，可以使复制粘贴操作变得简便快速。Excel 中复制粘贴操作常用快捷键有以下几种：</p>
<h2 id="Ctrl-C-和-Ctrl-V"><a href="#Ctrl-C-和-Ctrl-V" class="headerlink" title="Ctrl + C 和 Ctrl + V"></a>Ctrl + C 和 Ctrl + V</h2><p>Ctrl + C 为复制快捷键，其功能与右键菜单和功能区复制命令等效。Ctrl + V 为粘贴快捷键，其功能与右键菜单和功能区复制命令等效。</p>
<h2 id="Ctrl-Alt-V"><a href="#Ctrl-Alt-V" class="headerlink" title="Ctrl +Alt + V"></a>Ctrl +Alt + V</h2><p>Ctrl + Alt +V 为选择性粘贴快捷键，可以一步调出选择性粘贴菜单。</p>
<h2 id="Ctrl-D"><a href="#Ctrl-D" class="headerlink" title="Ctrl + D"></a>Ctrl + D</h2><p>Ctrl + D 快捷键将单元格或一行单元格数据复制粘贴到下方单元格或一行单元格。有两种使用方法：</p>
<p>1.如果在一行中选择一个或多个单元格并按 Ctrl+D 快捷键，选中区域上方的相同大小的区域的内容会复制粘贴到选中区域。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_8a7a573cf897c87ff7eed1175769e7b8.gif"></p>
<p>2.如果选中多行区域并按 Ctrl + D 快捷键，选中区域中第一行的数据将复制粘贴到选中区域的其他行内。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_bdd53977def240fd79a2e78d4d562ba3.gif"></p>
<h2 id="Ctrl-R"><a href="#Ctrl-R" class="headerlink" title="Ctrl + R"></a>Ctrl + R</h2><p>Ctrl + R 快捷键将单元格或一列单元格数据复制粘贴到右方单元格或一列单元格。有两种使用方法，用法类似向下复制的 Ctrl + D 快捷键类似。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/use-hot-key-copy/" data-id="clatcwg6l00rhxcq6ecblein6" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-use-conditional-paste-transfer" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/use-conditional-paste-transfer/" class="article-date">
  <time datetime="2022-11-23T08:00:49.368Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/">复制与粘贴</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/%E5%9F%BA%E7%A1%80/">基础</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/use-conditional-paste-transfer/">使用选择性粘贴对数据区域进行转置</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>有时根据需求，需要对已设置好的表格进行行和列转换，这时使用选择性粘贴功能的转置选项可快速实现需求。具体步骤如下：</p>
<p>1.选中需要进行转置的单元格区域。</p>
<p>2.进行复制操作。</p>
<p>3.选择需要转置到的位置。</p>
<p>4.打开选择性粘贴菜单。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_0064af58bc88da59cc9831c40839be91.png"></p>
<p>5.选择选择性粘贴选项中的转置选项，点击确定完成转置。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_1924bb0bf13d5681a052747450cc4cc0.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/use-conditional-paste-transfer/" data-id="clatcwg6n00rjxcq6chgd7ci6" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-lock-cell" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-lock-cell/" class="article-date">
  <time datetime="2022-11-23T08:00:49.352Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E4%BF%9D%E6%8A%A4/">保护</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-lock-cell/">Excel 锁定单元格</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>锁定单元格与保护工作表功能组合使用。锁定的单元格只有在所在工作表设置成保护状态时才生效。</p>
<p>默认情况下，工作表所有单元格是保护状态。针对指定单元格或区域，可以选中该区域，右键点击，在弹出的快捷菜单中选择“设置单元格格式”命令，点击保护选项即可查看保护状态。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_773e8777b5054b87d685d2a3cfc41cb2.png"></p>
<p>当单元格不在锁定状态时，保护工作表对改单元格不会有保护作用。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-lock-cell/" data-id="clatcwg2n00ocxcq6gpga1036" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-print-basics-n-options" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-print-basics-n-options/" class="article-date">
  <time datetime="2022-11-23T08:00:49.352Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%89%93%E5%8D%B0/">打印</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%89%93%E5%8D%B0/%E5%9F%BA%E7%A1%80/">基础</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-print-basics-n-options/">Excel 打印基础操作及打印选项</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <h2 id="打印菜单"><a href="#打印菜单" class="headerlink" title="打印菜单"></a>打印菜单</h2><p>进入打印菜单可以使用以下方法。</p>
<p><strong>方法一：</strong>点击功能区“文件”命令按钮，在弹出的左边命令菜单选择“打印”。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_3aaad0b8aee47a95c2330de11df8e7f5.png"></p>
<p><strong>方法二：</strong>使用快捷键 Ctrl +P 进入打印菜单。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_c88d854df6ba9e09d14ff441b3fb2f12.png"></p>
<h2 id="打印选项"><a href="#打印选项" class="headerlink" title="打印选项"></a>打印选项</h2><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_411365d96ef7cb8f3767f1ed5f48b441.png"></p>
<h2 id="设置打印区域"><a href="#设置打印区域" class="headerlink" title="设置打印区域"></a>设置打印区域</h2><p>在打印菜单设置下方可选择打印区域，打印区域可设置为活动工作表、整个工作簿和选定区域。在此基础上进一步制定打印范围，即指定页到指定页。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_2e34bc9e56e0b5dec4fa145597e7874c.png"></p>
<h2 id="设置打印份数"><a href="#设置打印份数" class="headerlink" title="设置打印份数"></a>设置打印份数</h2><p>在打印命令按钮旁，份数选项指定打印份数。如打印区域大于一页，在设置→调整选项可以指定打印方式（假定一份有3页）：</p>
<p>1.按顺序打印。这种方式先打印整个第一份，即按顺序打印1、2、3页；再打印下一份，即又按顺序打印1、2、3页。</p>
<p>2.取消排序打印。这种方式先打印所有的第1页，再打印所有的第3页，以此类推。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_98cbf1dbfe27d4f0159e629baf4319ca.png"></p>
<h2 id="设置打印方向"><a href="#设置打印方向" class="headerlink" title="设置打印方向"></a>设置打印方向</h2><p>根据需求，对打印区域可以设置横向和纵向的打印方式。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_2602197d195e2ce6ca7065302475a765.png"></p>
<h2 id="设置打印边距"><a href="#设置打印边距" class="headerlink" title="设置打印边距"></a>设置打印边距</h2><p>使用边距选项，可以指定打印边距：从预设的边距（普通、宽和窄）选择或者自定义边距。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_dc42e145ab15cb4a140b4d5cbc45476a.png"></p>
<h2 id="设置打印缩放比例"><a href="#设置打印缩放比例" class="headerlink" title="设置打印缩放比例"></a>设置打印缩放比例</h2><p>如果打印区域超出一页宽度或高度，可以对打印区域进行缩放，使打印区域缩小到一页宽或一页高或一页。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_389b2b7fe832a28d7c00d9fa496504e7.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-print-basics-n-options/" data-id="clatcwg3g00oyxcq66pv2hd0i" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-protect-sheet" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-protect-sheet/" class="article-date">
  <time datetime="2022-11-23T08:00:49.352Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E4%BF%9D%E6%8A%A4/">保护</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-protect-sheet/">Excel 保护工作表</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <h2 id="保护工作表命令位置"><a href="#保护工作表命令位置" class="headerlink" title="保护工作表命令位置"></a>保护工作表命令位置</h2><p>位置一：功能区→审阅选项卡→更改命令组</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_bb0b1fae66010f441267ad8cb93c5e67.png"></p>
<p>位置二：右键点击工作表标签，在弹出的快捷菜单中。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_68fe47532e1c1365b695d1762f0bfae1.png"></p>
<h2 id="保护工作表操作"><a href="#保护工作表操作" class="headerlink" title="保护工作表操作"></a>保护工作表操作</h2><p>1.点击保护工作表命令按钮，调出保护工作表菜单。</p>
<p>2.在“取消工作表保护时使用的密码”框中输入密码，当取消保护工作表时要求输入。如果改密码框留空，则取消保护工作表时不需要输入密码即可取消。</p>
<p>3.在下方的操作列表中，允许用户进行操作前打勾。不打勾的操作，用户无法进行。</p>
<p>4.点击确定完成保护工作表。如设置密码，需要两次输入密码确定。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_ec37d376204af9113259a721ca959a8f.png"></p>
<h2 id="取消保护工作表"><a href="#取消保护工作表" class="headerlink" title="取消保护工作表"></a>取消保护工作表</h2><p>当工作表在保护状态时，原“保护工作表”命令变为“撤销工作表保护”。在功能区或工作表标签右键弹出菜单中，点击“撤销工作表保护”命令按钮。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_1a4dcd13a93fb9a7c34b2ba57212e3bf.png"></p>
<p>情形一：如未设置取消工作表保护密码，则可以直接取消保护。</p>
<p>情形二：如设置了取消工作表保护密码，则在弹出的“撤销工作表保护”菜单中输入密码，取消保护。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_b4c544027a3b80be3374bdb0e680097c.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-protect-sheet/" data-id="clatcwg3i00p0xcq66cc544nq" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  


  <nav id="page-nav">
    
    <a class="extend prev" rel="prev" href="/study-excel/page/51/">&amp;laquo; 上一页</a><a class="page-number" href="/study-excel/">1</a><span class="space">&hellip;</span><a class="page-number" href="/study-excel/page/50/">50</a><a class="page-number" href="/study-excel/page/51/">51</a><span class="page-number current">52</span><a class="page-number" href="/study-excel/page/53/">53</a><a class="page-number" href="/study-excel/page/54/">54</a><span class="space">&hellip;</span><a class="page-number" href="/study-excel/page/94/">94</a><a class="extend next" rel="next" href="/study-excel/page/53/">下一页 &amp;raquo;</a>
  </nav>

</section>
        
          <aside id="sidebar">
  
    
  <div class="widget-wrap">
    <h3 class="widget-title">分类</h3>
    <div class="widget">
      <ul class="category-list"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/VBA/">VBA</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%85%AC%E5%BC%8F/">公式</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">公式基础</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E9%94%99%E8%AF%AF/">公式错误</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD/">功能</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F/">公式</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/">单元格引用</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/%E5%9F%BA%E7%A1%80/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E4%BD%BF%E7%94%A8-Excel/">使用 Excel</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F/">函数与公式</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E5%8D%95%E5%85%83%E6%A0%BC/">单元格</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E4%BF%9D%E5%AD%98%E8%AE%BE%E7%BD%AE/">保存设置</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E8%AE%BE%E7%BD%AE/">公式设置</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E5%85%B6%E4%BB%96%E8%AE%BE%E7%BD%AE/">其他设置</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E4%BF%9D%E6%8A%A4/">保护</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%A4%8D%E5%88%B6%E5%85%AC%E5%BC%8F/">复制公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%A4%8D%E5%88%B6%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%AE%A1%E9%98%85/">审阅</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%AE%A1%E9%98%85/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/">工作界面</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%81%E6%9C%AF%E8%AF%AD/">常见术语</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%81%E6%9C%AF%E8%AF%AD/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%84%E8%AE%BE%E7%BD%AE/">常规设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%84%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%BC%80%E5%A7%8B/">开始</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%BC%80%E5%A7%8B/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%8F%92%E5%85%A5/">插入</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%8F%92%E5%85%A5/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%95%B0%E6%8D%AE/">数据</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%95%B0%E6%8D%AE/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2007/">Excel 2007</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2010/">Excel 2010</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2013/">Excel 2013</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2016/">Excel 2016</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%A0%A1%E5%AF%B9%E8%AE%BE%E7%BD%AE/">校对设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%A0%A1%E5%AF%B9%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E5%86%99%E5%85%AC%E5%BC%8F/">编写公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E5%86%99%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E8%BE%91%E5%85%AC%E5%BC%8F/">编辑公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E8%BE%91%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E8%A7%86%E5%9B%BE/">视图</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E8%A7%86%E5%9B%BE/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%A1%B5%E9%9D%A2%E5%B8%83%E5%B1%80/">页面布局</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%A1%B5%E9%9D%A2%E5%B8%83%E5%B1%80/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%AB%98%E7%BA%A7%E8%AE%BE%E7%BD%AE/">高级设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%AB%98%E7%BA%A7%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%BC%A0%E6%A0%87%E6%8C%87%E9%92%88/">鼠标指针</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%BC%A0%E6%A0%87%E6%8C%87%E9%92%88/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/">复制与粘贴</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%89%93%E5%8D%B0/">打印</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%89%93%E5%8D%B0/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%9F%A5%E6%89%BE%E4%B8%8E%E9%80%89%E6%8B%A9/">查找与选择</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%9F%A5%E6%89%BE%E4%B8%8E%E9%80%89%E6%8B%A9/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%8D%95%E5%85%83%E6%A0%BC%E6%A0%BC%E5%BC%8F/">编辑单元格格式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%8D%95%E5%85%83%E6%A0%BC%E6%A0%BC%E5%BC%8F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8/">编辑工作表</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%8C%BA%E5%9F%9F/">编辑工作表区域</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%8C%BA%E5%9F%9F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E6%95%B0%E5%AD%97%E6%A0%BC%E5%BC%8F/">编辑数字格式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E6%95%B0%E5%AD%97%E6%A0%BC%E5%BC%8F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E9%BC%A0%E6%A0%87%E6%93%8D%E4%BD%9C/">鼠标操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E9%BC%A0%E6%A0%87%E6%93%8D%E4%BD%9C/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%BF%AB%E6%8D%B7%E9%94%AE/">快捷键</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E9%97%AE%E9%A2%98/">问题</a></li></ul>
    </div>
  </div>


  
    

  
    
  
    
  <div class="widget-wrap">
    <h3 class="widget-title">归档</h3>
    <div class="widget">
      <ul class="archive-list"><li class="archive-list-item"><a class="archive-list-link" href="/study-excel/archives/2022/11/">十一月 2022</a></li></ul>
    </div>
  </div>


  
    
  <div class="widget-wrap">
    <h3 class="widget-title">最新文章</h3>
    <div class="widget">
      <ul>
        
          <li>
            <a href="/study-excel/excel-coupdaybs-function/">Excel COUPDAYBS 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupdays-function/">Excel COUPDAYS 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupdaysnc-function/">Excel COUPDAYSNC 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupncd-function/">Excel COUPNCD 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupnum-function/">Excel COUPNUM 函数</a>
          </li>
        
      </ul>
    </div>
  </div>

  
</aside>
        
      </div>
      <footer id="footer">
  
  <div class="outer">
    <div id="footer-info" class="inner">
      &copy; 2022 lijile<br>
      Powered by <a href="http://hexo.io/" target="_blank">Hexo</a>
    </div>
  </div>
</footer>
    </div>
    <nav id="mobile-nav">
  
    <a href="/study-excel/" class="mobile-nav-link">Home</a>
  
    <a href="/study-excel/archives" class="mobile-nav-link">Archives</a>
  
</nav>
    

<script src="//ajax.googleapis.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>


  
<link rel="stylesheet" href="/study-excel/fancybox/jquery.fancybox.css">

  
<script src="/study-excel/fancybox/jquery.fancybox.pack.js"></script>




<script src="/study-excel/js/script.js"></script>




  </div>
</body>
</html>